/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 13/09/2025 15:07:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_user
-- ----------------------------
DROP TABLE IF EXISTS `sc_user`;
CREATE TABLE `sc_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码（BCrypt加密）',
  `phone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `real_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名',
  `id_card` varchar(18) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '身份证号',
  `avatar` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像地址',
  `gender` int(11) DEFAULT '0' COMMENT '性别：0-未知，1-男，2-女',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '住址',
  `user_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户类型：SUPER_ADMIN-超级管理员，PROPERTY_ADMIN-物业管理员，COMMUNITY_ADMIN-社区管理员，BUILDING_ADMIN-楼栋管理员，UNIT_ADMIN-单元管理员，HOUSEHOLD_ADMIN-房户管理员，NORMAL_USER-普通用户',
  `status` int(11) DEFAULT '1' COMMENT '状态：0-禁用，1-启用，2-待审核，3-锁定',
  `audit_status` int(11) DEFAULT '0' COMMENT '审核状态：0-待审核，1-审核通过，2-审核拒绝',
  `is_admin_protected` int(11) DEFAULT '0' COMMENT '是否Admin保护：0-否，1-是',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后登录IP',
  `login_fail_count` int(11) DEFAULT '0' COMMENT '登录失败次数',
  `lock_time` datetime DEFAULT NULL COMMENT '锁定时间',
  `organization_id` bigint(20) DEFAULT NULL COMMENT '所属组织ID',
  `property_company_id` bigint(20) DEFAULT NULL COMMENT '物业公司ID',
  `community_id` bigint(20) DEFAULT NULL COMMENT '所属社区ID',
  `building_id` bigint(20) DEFAULT NULL COMMENT '楼栋ID',
  `unit_id` bigint(20) DEFAULT NULL COMMENT '单元ID',
  `household_id` bigint(20) DEFAULT NULL COMMENT '房户ID',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int(11) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `version` int(11) DEFAULT '1' COMMENT '版本号',
  `remark` text COLLATE utf8mb4_unicode_ci COMMENT '备注',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_username` (`username`),
  UNIQUE KEY `uk_phone` (`phone`),
  UNIQUE KEY `uk_id_card` (`id_card`),
  KEY `idx_email` (`email`),
  KEY `idx_community_id` (`community_id`),
  KEY `idx_audit_status` (`audit_status`),
  KEY `idx_status_user_type` (`status`,`user_type`),
  KEY `idx_community_status` (`community_id`,`status`),
  KEY `idx_create_time_status` (`create_time`,`status`),
  KEY `idx_deleted_status` (`deleted`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';

-- ----------------------------
-- Records of sc_user
-- ----------------------------
BEGIN;
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (1, 'wuliang', '0192023a7bbd73250516f069df18b500', '13567114714', '369222136@qq.com', '吴樑', '330184198511181815', NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 0, 0, NULL, NULL, 0, NULL, NULL, 1, 1, NULL, NULL, NULL, 1, '2025-07-09 05:25:29', NULL, '2025-08-05 11:00:08', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (6, 'gufeiya2', '0192023a7bbd73250516f069df18b500', '13800138002', 'test2-edited@example.com', '测试用户2-已编辑', NULL, NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 1, 0, '2025-06-30 14:33:07', '127.0.0.1', 0, NULL, NULL, 1011, NULL, NULL, NULL, NULL, 1, NULL, 1, '2025-08-08 02:10:03', 0, 2, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (7, 'gufeiya3', '0192023a7bbd73250516f069df18b500', '13800138003', 'test3-edited@example.com', '测试用户3-已编辑', NULL, NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 1, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, NULL, NULL, NULL, 1, NULL, 1, '2025-07-16 17:23:13', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (9, 'gufeiya', '0192023a7bbd73250516f069df18b500', '13800138011', 'wz_admin@example.com', '胖胖', '330185198511181815', NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 0, 0, '2025-06-30 15:12:25', '127.0.0.1', 0, NULL, NULL, 2, 1, NULL, NULL, NULL, 1, '2025-06-30 06:14:43', 1, '2025-07-16 17:23:27', 0, 2, NULL, '智慧管理员');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (11, 'ls_admin', '0192023a7bbd73250516f069df18b500', '13800138021', 'ls_admin@example.com', '绿色物业管理员', NULL, NULL, 0, NULL, NULL, 'SUPER_ADMIN', 1, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-06-30 06:14:43', 1, '2025-07-07 07:40:03', 0, 1, NULL, '绿色管理员');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (13, 'hx_admin', '0192023a7bbd73250516f069df18b500', '13800138031', 'hx_admin@example.com', '和谐物业管理员', NULL, NULL, 0, NULL, NULL, 'SUPER_ADMIN', 1, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-06-30 06:14:43', 1, '2025-07-07 07:40:02', 0, 1, NULL, '和谐管理员');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (14, 'resident1', '0192023a7bbd73250516f069df18b500', '13800138100', 'resident1@example.com', '张居民', NULL, NULL, 0, NULL, NULL, 'NORMAL_USER', 1, 0, 0, '2025-06-30 15:14:00', '127.0.0.1', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-06-30 06:14:43', 1, '2025-07-07 07:40:04', 0, 1, NULL, '张居民');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (16, 'wuliang3', '0192023a7bbd73250516f069df18b500', '13800138004', 'property4@test.com', '物业用户4', NULL, NULL, 0, NULL, NULL, 'SUPER_ADMIN', 1, 1, 0, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, 1, NULL, 1, '2025-07-16 17:23:40', 0, 1, NULL, '物业用户4');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (24, 'admin', '0192023a7bbd73250516f069df18b500', '13800138001', 'admin@smart-community.com', '系统管理员', NULL, NULL, 0, NULL, NULL, 'SUPER_ADMIN', 1, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-07-05 15:57:54', 24, '2025-08-31 20:52:10', 0, 1, NULL, '超管');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (25, 'wuliang2', '0192023a7bbd73250516f069df18b500', '13800138000', 'test@example.com', '测试用户', NULL, NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 0, 0, NULL, NULL, 0, NULL, NULL, 1010, NULL, NULL, NULL, NULL, 1, '2025-07-05 15:57:54', 1, '2025-07-16 17:23:43', 0, 5, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (30, 'gufeiya4', '0192023a7bbd73250516f069df18b500', '13678909876', 'gufeiya@163.com', 'gufeiya', '332184198511181818', NULL, 2, '2025-09-01', NULL, 'COMMUNITY_ADMIN', 1, 0, 0, NULL, NULL, 0, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, '2025-07-17 23:04:48', NULL, '2025-08-08 04:38:49', 0, 2, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (31, '13567114715', 'd2db2e87bcc865f719d825b31bc6ae2a', '13567114715', '2565760135@qq.com', '小毛毛', '330184201611071815', '{\"id\":1756702022239,\"status\":\"success\",\"fileUrl\":\"http://localhost:9000/smart-community/avatar/31/avatar_31_1756702022226.jpg\",\"fileName\":\"avatar_31_1756702022226.jpg\",\"filePath\":\"avatar/31/avatar_31_1756702022226.jpg\",\"fileSize\":86213,\"fileType\":\"image/jpeg\",\"createTime\":\"2025-09-01T04:47:02.258Z\",\"uploadType\":\"USER_AVATAR\",\"uploadSource\":\"APP\",\"fileExtension\":\"jpg\",\"originalFileName\":\"微信图片_20250411112444.jpg\"}', 1, '2016-11-07', NULL, 'PROPERTY_ADMIN', 1, 1, 0, NULL, NULL, 0, NULL, NULL, 1007, NULL, NULL, NULL, NULL, NULL, '2025-08-05 11:15:14', 31, '2025-09-01 12:48:08', 0, 5, NULL, '小毛毛');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (32, '18329188129', '0192023a7bbd73250516f069df18b500', '18329188129', '18329188129@139.com', '小呱呱', '330184198511181814', NULL, 2, '2020-08-05', NULL, 'PROPERTY_ADMIN', 1, 1, 0, NULL, NULL, 0, NULL, NULL, 1013, NULL, NULL, NULL, NULL, NULL, '2025-08-05 11:32:10', NULL, '2025-08-05 03:59:24', 0, 2, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (33, '13567114712', '0192023a7bbd73250516f069df18b500', '13567114712', NULL, '小呱呱', NULL, NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 1, 0, NULL, NULL, 0, NULL, NULL, 1009, NULL, NULL, NULL, NULL, NULL, '2025-08-07 16:38:40', NULL, '2025-08-08 04:38:46', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (34, 'xiaoguagua', '0192023a7bbd73250516f069df18b500', '13567114710', '13567114710@139.com', 'xiaoguagua', NULL, NULL, 0, NULL, NULL, 'COMMUNITY_ADMIN', 1, 0, 0, NULL, NULL, 0, NULL, NULL, 1010, NULL, NULL, NULL, NULL, 24, '2025-08-07 20:11:30', NULL, '2025-08-08 04:38:48', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (35, '13566666666', '0192023a7bbd73250516f069df18b500', '13566666666', '13566666666@139.com', 'WULIANG', NULL, NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 1, 0, NULL, NULL, 0, NULL, NULL, 1014, NULL, NULL, NULL, NULL, NULL, '2025-08-08 16:16:43', 35, '2025-08-26 14:15:29', 0, 3, NULL, 'Wu.Liang');
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (36, '330185198911181815', '0192023a7bbd73250516f069df18b500', NULL, NULL, '吴樑一号', '330185198911181815', NULL, 2, '2020-07-09', NULL, 'NORMAL_USER', 1, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, '2025-08-09 15:00:05', 35, '2025-08-25 06:15:22', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (37, '13444444444', 'e10adc3949ba59abbe56e057f20f883e', '13444444444', NULL, '新毛毛', '330200200001010000', NULL, 2, NULL, NULL, 'NORMAL_USER', 1, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, '2025-08-15 16:18:38', 35, '2025-08-15 16:18:38', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (38, '13577777777', 'e10adc3949ba59abbe56e057f20f883e', '13577777777', NULL, '新猫咪', '330184199001011814', NULL, 1, NULL, NULL, 'NORMAL_USER', 1, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, '2025-08-18 14:20:24', 35, '2025-08-18 14:20:24', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (39, '13811111111', 'e10adc3949ba59abbe56e057f20f883e', '13811111111', NULL, '屋梁', '110584199001015874', NULL, 1, NULL, NULL, 'NORMAL_USER', 1, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, '2025-08-22 10:37:53', 35, '2025-08-22 10:37:53', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (40, '13800138999', '9631745ce0d9b995ea7de8ad1f04dd70', '13800138999', 'test4@example.com', '测试业主4', '110101199001011237', NULL, 1, '1990-01-01', NULL, 'NORMAL_USER', 1, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24, '2025-08-22 12:13:35', 24, '2025-08-22 12:13:35', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (41, '13111111111', 'c5f3ec33f1ef1f1f94fb8e4fdd23dec5', '13111111111', NULL, '进口量', '330184198511111111', NULL, 1, '2025-08-18', NULL, 'NORMAL_USER', 1, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, '2025-08-22 13:19:57', 35, '2025-08-22 13:19:57', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (42, '19558156907', '66ffbf2efc93154e3b723a59dadeea5d', '19558156907', NULL, '毛哥', NULL, NULL, 0, NULL, NULL, 'PROPERTY_ADMIN', 1, 1, 0, NULL, NULL, 0, NULL, NULL, 1015, NULL, NULL, NULL, NULL, NULL, '2025-08-28 10:10:04', NULL, '2025-08-28 10:10:04', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (44, 'XiaoGuaGuaNew', 'e10adc3949ba59abbe56e057f20f883e', '19558156908', '19558156908@139.com', '瓜哥', NULL, NULL, 0, NULL, NULL, 'REPAIR_STAFF', 1, 0, 0, NULL, NULL, 0, NULL, NULL, 1015, NULL, NULL, NULL, NULL, 42, '2025-08-28 13:13:33', 42, '2025-08-28 13:13:33', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (45, '19558156909', 'e10adc3949ba59abbe56e057f20f883e', '19558156909', NULL, '瓜哥', '330184201411071818', NULL, 2, NULL, NULL, 'NORMAL_USER', 1, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 42, '2025-08-28 15:14:46', 42, '2025-08-28 15:14:46', 0, 1, NULL, NULL);
INSERT INTO `sc_user` (`id`, `username`, `password`, `phone`, `email`, `real_name`, `id_card`, `avatar`, `gender`, `birthday`, `address`, `user_type`, `status`, `audit_status`, `is_admin_protected`, `last_login_time`, `last_login_ip`, `login_fail_count`, `lock_time`, `organization_id`, `property_company_id`, `community_id`, `building_id`, `unit_id`, `household_id`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`, `remark`, `nickname`) VALUES (46, '13566666667', 'e10adc3949ba59abbe56e057f20f883e', '13566666667', '13566666666@139.com', '张居民', NULL, NULL, 0, NULL, NULL, 'REPAIR_STAFF', 1, 0, 0, NULL, NULL, 0, NULL, NULL, 1015, NULL, NULL, NULL, NULL, 42, '2025-09-01 17:42:46', 42, '2025-09-01 17:43:03', 0, 2, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
